Dataset statistics
| Number of variables | 41 |
|---|---|
| Number of observations | 416198 |
| Missing cells | 882896 |
| Missing cells (%) | 5.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 130.2 MiB |
| Average record size in memory | 328.0 B |
Variable types
| CAT | 23 |
|---|---|
| NUM | 15 |
| BOOL | 3 |
Reproduction
| Analysis started | 2020-07-06 14:13:38.578395 |
|---|---|
| Analysis finished | 2020-07-06 14:16:05.130988 |
| Duration | 2 minutes and 26.55 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
RD_NO has a high cardinality: 412429 distinct values | High cardinality |
CRASH_DATE has a high cardinality: 269126 distinct values | High cardinality |
DATE_POLICE_NOTIFIED has a high cardinality: 318866 distinct values | High cardinality |
STREET_NAME has a high cardinality: 1549 distinct values | High cardinality |
LOCATION has a high cardinality: 188585 distinct values | High cardinality |
LONGITUDE is highly correlated with LATITUDE | High correlation |
LATITUDE is highly correlated with LONGITUDE | High correlation |
LANE_CNT has 217643 (52.3%) missing values | Missing |
REPORT_TYPE has 9854 (2.4%) missing values | Missing |
INTERSECTION_RELATED_I has 323233 (77.7%) missing values | Missing |
HIT_AND_RUN_I has 298508 (71.7%) missing values | Missing |
LANE_CNT is highly skewed (γ1 = 349.9037887) | Skewed |
LATITUDE is highly skewed (γ1 = -109.5963231) | Skewed |
LONGITUDE is highly skewed (γ1 = 118.3356283) | Skewed |
RD_NO is uniformly distributed | Uniform |
CRASH_DATE is uniformly distributed | Uniform |
DATE_POLICE_NOTIFIED is uniformly distributed | Uniform |
CRASH_RECORD_ID has unique values | Unique |
POSTED_SPEED_LIMIT has 6598 (1.6%) zeros | Zeros |
LANE_CNT has 8011 (1.9%) zeros | Zeros |
INJURIES_TOTAL has 362531 (87.1%) zeros | Zeros |
INJURIES_INCAPACITATING has 407047 (97.8%) zeros | Zeros |
INJURIES_NON_INCAPACITATING has 384446 (92.4%) zeros | Zeros |
INJURIES_REPORTED_NOT_EVIDENT has 395564 (95.0%) zeros | Zeros |
INJURIES_NO_INDICATION has 7217 (1.7%) zeros | Zeros |
CRASH_HOUR has 7955 (1.9%) zeros | Zeros |
| Distinct count | 416198 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| f15dd1b39f7524eb37e04fd1b543c4550722caceacd2bf34021cd6857a21038688c3156a48a306cecf929176acbe2ec703d3e00388a4ab30c34001c80367b831 | 1 |
|---|---|
| 1be2eecc95ba0fbb145bce867b6f21e6c7c9a3fcb31208aa3d2fa20fe12a7c5cf8eeaae24389026cd065ef7b1e03795f660fb229206ff2c5a97a5a3d480a38ec | 1 |
| 554d9ce368e66c697ea20c679fca1c2a18e5822a3a49964231e43aa0a1a9cac1f3cef6b7e88b955eda8e1aebb0c749a01b151577903fbcac0363b09ee529bdf2 | 1 |
| 2cd9ef75712e240e93d4dda66a1a8777a0d73660996f73a6481ff2ec5502c47b27942936d4c64b4dfc59b645010e9c9c823152e1c7401e4d214f0e65b260ba1c | 1 |
| 355299096b6010f84ce85a7839179b7346793149c614ae79c0403fe09e2e5f31500c63607512885ffec9bd1883c1d07a11058f784a761e46ac6ba655a32bc8b1 | 1 |
| Other values (416193) |
| Value | Count | Frequency (%) | |
| f15dd1b39f7524eb37e04fd1b543c4550722caceacd2bf34021cd6857a21038688c3156a48a306cecf929176acbe2ec703d3e00388a4ab30c34001c80367b831 | 1 | < 0.1% | |
| 1be2eecc95ba0fbb145bce867b6f21e6c7c9a3fcb31208aa3d2fa20fe12a7c5cf8eeaae24389026cd065ef7b1e03795f660fb229206ff2c5a97a5a3d480a38ec | 1 | < 0.1% | |
| 554d9ce368e66c697ea20c679fca1c2a18e5822a3a49964231e43aa0a1a9cac1f3cef6b7e88b955eda8e1aebb0c749a01b151577903fbcac0363b09ee529bdf2 | 1 | < 0.1% | |
| 2cd9ef75712e240e93d4dda66a1a8777a0d73660996f73a6481ff2ec5502c47b27942936d4c64b4dfc59b645010e9c9c823152e1c7401e4d214f0e65b260ba1c | 1 | < 0.1% | |
| 355299096b6010f84ce85a7839179b7346793149c614ae79c0403fe09e2e5f31500c63607512885ffec9bd1883c1d07a11058f784a761e46ac6ba655a32bc8b1 | 1 | < 0.1% | |
| e362d43c64ae3ca4172851659d5744a7b95701589a43a3bee036a27904cd112bf685d08f725dd72c16830d10d534e97ae0910a2a25b9f9cb1a983d7a1de60d6f | 1 | < 0.1% | |
| f9cc1acdd334027a374d7d2dbe91f751b6fdcc88b44bf8f7a7535b97c5b6a9d3bf283b2d3a662c85b5dd46843e89cc6d4e1f9652fdf8a9b6da30c18e50157ad2 | 1 | < 0.1% | |
| 62a80219868d83f66c9ebe89f04aab8322454250e8cbf2efdd01ec8beb6f305e27e6506789e39c051a3fa27bbb8a27d18ff124813c66f0a9a266ee72f6dd3d02 | 1 | < 0.1% | |
| f81b2af19bda5e335a2b8e6a3d80838b46e791b9df54698e450bcb8980cb5a8c2168fb62468b3ccc4c76eaeb3aa93052bd9182db52e1ab5dda3c259f6dffeac5 | 1 | < 0.1% | |
| 5ece44b15c211231a91804b0e7566af4fcfed70639b184b4e8ffb66c93e06ea6a7e7c82f1dc8509804554d64824475da2c641c1266c1d01aef8abc354a2a225a | 1 | < 0.1% | |
| Other values (416188) | 416188 | > 99.9% |
Length
| Max length | 128 |
|---|---|
| Median length | 128 |
| Mean length | 128 |
| Min length | 128 |
| Distinct count | 412429 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 3769 |
| Missing (%) | 0.9% |
| Memory size | 3.2 MiB |
| JB542414 | 1 |
|---|---|
| JC342313 | 1 |
| JB420157 | 1 |
| JB544230 | 1 |
| JB491934 | 1 |
| Other values (412424) |
| Value | Count | Frequency (%) | |
| JB542414 | 1 | < 0.1% | |
| JC342313 | 1 | < 0.1% | |
| JB420157 | 1 | < 0.1% | |
| JB544230 | 1 | < 0.1% | |
| JB491934 | 1 | < 0.1% | |
| JC161138 | 1 | < 0.1% | |
| JC463125 | 1 | < 0.1% | |
| JB350707 | 1 | < 0.1% | |
| HZ359951 | 1 | < 0.1% | |
| JB150690 | 1 | < 0.1% | |
| Other values (412419) | 412419 | 99.1% | |
| (Missing) | 3769 | 0.9% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.95472107 |
| Min length | 3 |
| Distinct count | 269126 |
|---|---|
| Unique (%) | 64.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| 11/10/2017 10:30:00 AM | 27 |
|---|---|
| 11/10/2017 10:00:00 AM | 20 |
| 01/12/2019 02:30:00 PM | 20 |
| 01/12/2019 02:00:00 PM | 18 |
| 01/12/2019 03:00:00 PM | 18 |
| Other values (269121) |
| Value | Count | Frequency (%) | |
| 11/10/2017 10:30:00 AM | 27 | < 0.1% | |
| 11/10/2017 10:00:00 AM | 20 | < 0.1% | |
| 01/12/2019 02:30:00 PM | 20 | < 0.1% | |
| 01/12/2019 02:00:00 PM | 18 | < 0.1% | |
| 01/12/2019 03:00:00 PM | 18 | < 0.1% | |
| 02/26/2020 07:45:00 AM | 17 | < 0.1% | |
| 09/04/2018 08:00:00 AM | 16 | < 0.1% | |
| 01/12/2019 04:00:00 PM | 16 | < 0.1% | |
| 02/26/2020 08:00:00 AM | 16 | < 0.1% | |
| 02/10/2019 02:00:00 PM | 15 | < 0.1% | |
| Other values (269116) | 416015 | > 99.9% |
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
| Distinct count | 42 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.262797995184982 |
|---|---|
| Minimum | 0 |
| Maximum | 99 |
| Zeros | 6598 |
| Zeros (%) | 1.6% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 15 |
| Q1 | 30 |
| median | 30 |
| Q3 | 30 |
| 95-th percentile | 35 |
| Maximum | 99 |
| Range | 99 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 6.591077534 |
|---|---|
| Coefficient of variation (CV) | 0.2332068302 |
| Kurtosis | 8.500474378 |
| Mean | 28.262798 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.918221926 |
| Sum | 11762920 |
| Variance | 43.44230306 |
| Value | Count | Frequency (%) | |
| 30 | 306912 | 73.7% | |
| 35 | 28469 | 6.8% | |
| 25 | 24953 | 6.0% | |
| 20 | 16016 | 3.8% | |
| 15 | 14243 | 3.4% | |
| 10 | 8428 | 2.0% | |
| 0 | 6598 | 1.6% | |
| 40 | 3739 | 0.9% | |
| 5 | 3434 | 0.8% | |
| 45 | 2476 | 0.6% | |
| Other values (32) | 930 | 0.2% |
| Value | Count | Frequency (%) | |
| 0 | 6598 | 1.6% | |
| 1 | 35 | < 0.1% | |
| 2 | 19 | < 0.1% | |
| 3 | 104 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 99 | 67 | < 0.1% | |
| 70 | 3 | < 0.1% | |
| 65 | 9 | < 0.1% | |
| 63 | 1 | < 0.1% | |
| 60 | 26 | < 0.1% |
TRAFFIC_CONTROL_DEVICE
Categorical
| Distinct count | 19 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| NO CONTROLS | |
|---|---|
| TRAFFIC SIGNAL | |
| STOP SIGN/FLASHER | 40941 |
| UNKNOWN | 13406 |
| OTHER | 2497 |
| Other values (14) | 3703 |
| Value | Count | Frequency (%) | |
| NO CONTROLS | 239527 | 57.6% | |
| TRAFFIC SIGNAL | 116124 | 27.9% | |
| STOP SIGN/FLASHER | 40941 | 9.8% | |
| UNKNOWN | 13406 | 3.2% | |
| OTHER | 2497 | 0.6% | |
| LANE USE MARKING | 1224 | 0.3% | |
| YIELD | 595 | 0.1% | |
| OTHER REG. SIGN | 400 | 0.1% | |
| OTHER WARNING SIGN | 369 | 0.1% | |
| RAILROAD CROSSING GATE | 286 | 0.1% | |
| Other values (9) | 829 | 0.2% |
Length
| Max length | 24 |
|---|---|
| Median length | 11 |
| Mean length | 12.29793271 |
| Min length | 5 |
DEVICE_CONDITION
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| NO CONTROLS | |
|---|---|
| FUNCTIONING PROPERLY | |
| UNKNOWN | 22621 |
| OTHER | 3213 |
| FUNCTIONING IMPROPERLY | 2333 |
| Other values (3) | 1597 |
| Value | Count | Frequency (%) | |
| NO CONTROLS | 241838 | 58.1% | |
| FUNCTIONING PROPERLY | 144596 | 34.7% | |
| UNKNOWN | 22621 | 5.4% | |
| OTHER | 3213 | 0.8% | |
| FUNCTIONING IMPROPERLY | 2333 | 0.6% | |
| NOT FUNCTIONING | 1350 | 0.3% | |
| WORN REFLECTIVE MATERIAL | 192 | < 0.1% | |
| MISSING | 55 | < 0.1% |
Length
| Max length | 24 |
|---|---|
| Median length | 11 |
| Mean length | 13.94316888 |
| Min length | 5 |
WEATHER_CONDITION
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| CLEAR | |
|---|---|
| RAIN | 38322 |
| UNKNOWN | 17924 |
| SNOW | 15638 |
| CLOUDY/OVERCAST | 12782 |
| Other values (7) | 3310 |
| Value | Count | Frequency (%) | |
| CLEAR | 328222 | 78.9% | |
| RAIN | 38322 | 9.2% | |
| UNKNOWN | 17924 | 4.3% | |
| SNOW | 15638 | 3.8% | |
| CLOUDY/OVERCAST | 12782 | 3.1% | |
| OTHER | 1337 | 0.3% | |
| FOG/SMOKE/HAZE | 782 | 0.2% | |
| SLEET/HAIL | 655 | 0.2% | |
| FREEZING RAIN/DRIZZLE | 384 | 0.1% | |
| SEVERE CROSS WIND GATE | 88 | < 0.1% | |
| Other values (2) | 64 | < 0.1% |
Length
| Max length | 24 |
|---|---|
| Median length | 5 |
| Mean length | 5.307836655 |
| Min length | 4 |
LIGHTING_CONDITION
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| DAYLIGHT | |
|---|---|
| DARKNESS, LIGHTED ROAD | |
| DARKNESS | 21134 |
| UNKNOWN | 14949 |
| DUSK | 12780 |
| Value | Count | Frequency (%) | |
| DAYLIGHT | 272789 | 65.5% | |
| DARKNESS, LIGHTED ROAD | 87268 | 21.0% | |
| DARKNESS | 21134 | 5.1% | |
| UNKNOWN | 14949 | 3.6% | |
| DUSK | 12780 | 3.1% | |
| DAWN | 7278 | 1.7% |
Length
| Max length | 22 |
|---|---|
| Median length | 8 |
| Mean length | 10.70681503 |
| Min length | 4 |
FIRST_CRASH_TYPE
Categorical
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| REAR END | |
|---|---|
| PARKED MOTOR VEHICLE | |
| SIDESWIPE SAME DIRECTION | |
| TURNING | |
| ANGLE | |
| Other values (13) |
| Value | Count | Frequency (%) | |
| REAR END | 101600 | 24.4% | |
| PARKED MOTOR VEHICLE | 93339 | 22.4% | |
| SIDESWIPE SAME DIRECTION | 66394 | 16.0% | |
| TURNING | 58260 | 14.0% | |
| ANGLE | 43642 | 10.5% | |
| FIXED OBJECT | 18304 | 4.4% | |
| PEDESTRIAN | 9861 | 2.4% | |
| SIDESWIPE OPPOSITE DIRECTION | 6142 | 1.5% | |
| PEDALCYCLIST | 5974 | 1.4% | |
| OTHER OBJECT | 3882 | 0.9% | |
| Other values (8) | 8800 | 2.1% |
Length
| Max length | 28 |
|---|---|
| Median length | 10 |
| Mean length | 13.46485807 |
| Min length | 5 |
TRAFFICWAY_TYPE
Categorical
| Distinct count | 20 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| NOT DIVIDED | |
|---|---|
| DIVIDED - W/MEDIAN (NOT RAISED) | |
| ONE-WAY | |
| PARKING LOT | 29929 |
| DIVIDED - W/MEDIAN BARRIER | 25175 |
| Other values (15) |
| Value | Count | Frequency (%) | |
| NOT DIVIDED | 187541 | 45.1% | |
| DIVIDED - W/MEDIAN (NOT RAISED) | 75538 | 18.1% | |
| ONE-WAY | 55263 | 13.3% | |
| PARKING LOT | 29929 | 7.2% | |
| DIVIDED - W/MEDIAN BARRIER | 25175 | 6.0% | |
| OTHER | 12103 | 2.9% | |
| FOUR WAY | 9384 | 2.3% | |
| ALLEY | 6684 | 1.6% | |
| UNKNOWN | 4556 | 1.1% | |
| CENTER TURN LANE | 3696 | 0.9% | |
| Other values (10) | 6329 | 1.5% |
Length
| Max length | 31 |
|---|---|
| Median length | 11 |
| Mean length | 14.67856645 |
| Min length | 4 |
| Distinct count | 41 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 217643 |
| Missing (%) | 52.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.35549847649266 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1191625.0 |
| Zeros | 8011 |
| Zeros (%) | 1.9% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 4 |
| Maximum | 1191625 |
| Range | 1191625 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2964.985076 |
|---|---|
| Coefficient of variation (CV) | 222.004823 |
| Kurtosis | 134371.3452 |
| Mean | 13.35549848 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 349.9037887 |
| Sum | 2651801 |
| Variance | 8791136.5 |
| Value | Count | Frequency (%) | |
| 2 | 90913 | 21.8% | |
| 4 | 49492 | 11.9% | |
| 1 | 32500 | 7.8% | |
| 3 | 8644 | 2.1% | |
| 0 | 8011 | 1.9% | |
| 6 | 4494 | 1.1% | |
| 5 | 1935 | 0.5% | |
| 8 | 1906 | 0.5% | |
| 7 | 184 | < 0.1% | |
| 10 | 161 | < 0.1% | |
| Other values (31) | 315 | 0.1% | |
| (Missing) | 217643 | 52.3% |
| Value | Count | Frequency (%) | |
| 0 | 8011 | 1.9% | |
| 1 | 32500 | 7.8% | |
| 2 | 90913 | 21.8% | |
| 3 | 8644 | 2.1% | |
| 4 | 49492 | 11.9% |
| Value | Count | Frequency (%) | |
| 1191625 | 1 | < 0.1% | |
| 433634 | 1 | < 0.1% | |
| 299679 | 1 | < 0.1% | |
| 218474 | 1 | < 0.1% | |
| 902 | 1 | < 0.1% |
ALIGNMENT
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| STRAIGHT AND LEVEL | |
|---|---|
| STRAIGHT ON GRADE | 5096 |
| CURVE, LEVEL | 3126 |
| STRAIGHT ON HILLCREST | 1343 |
| CURVE ON GRADE | 615 |
| Value | Count | Frequency (%) | |
| STRAIGHT AND LEVEL | 405811 | 97.5% | |
| STRAIGHT ON GRADE | 5096 | 1.2% | |
| CURVE, LEVEL | 3126 | 0.8% | |
| STRAIGHT ON HILLCREST | 1343 | 0.3% | |
| CURVE ON GRADE | 615 | 0.1% | |
| CURVE ON HILLCREST | 207 | < 0.1% |
Length
| Max length | 21 |
|---|---|
| Median length | 18 |
| Mean length | 17.94646058 |
| Min length | 12 |
ROADWAY_SURFACE_COND
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| DRY | |
|---|---|
| WET | 58746 |
| UNKNOWN | 27285 |
| SNOW OR SLUSH | 14891 |
| ICE | 3393 |
| Other values (2) | 1169 |
| Value | Count | Frequency (%) | |
| DRY | 310714 | 74.7% | |
| WET | 58746 | 14.1% | |
| UNKNOWN | 27285 | 6.6% | |
| SNOW OR SLUSH | 14891 | 3.6% | |
| ICE | 3393 | 0.8% | |
| OTHER | 971 | 0.2% | |
| SAND, MUD, DIRT | 198 | < 0.1% |
Length
| Max length | 15 |
|---|---|
| Median length | 3 |
| Mean length | 3.630392265 |
| Min length | 3 |
ROAD_DEFECT
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| NO DEFECTS | |
|---|---|
| UNKNOWN | 59680 |
| RUT, HOLES | 4187 |
| OTHER | 2395 |
| WORN SURFACE | 1709 |
| Other values (2) | 1286 |
| Value | Count | Frequency (%) | |
| NO DEFECTS | 346941 | 83.4% | |
| UNKNOWN | 59680 | 14.3% | |
| RUT, HOLES | 4187 | 1.0% | |
| OTHER | 2395 | 0.6% | |
| WORN SURFACE | 1709 | 0.4% | |
| SHOULDER DEFECT | 910 | 0.2% | |
| DEBRIS ON ROADWAY | 376 | 0.1% |
Length
| Max length | 17 |
|---|---|
| Median length | 10 |
| Mean length | 9.566516418 |
| Min length | 5 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 9854 |
| Missing (%) | 2.4% |
| Memory size | 3.2 MiB |
| NOT ON SCENE (DESK REPORT) | |
|---|---|
| ON SCENE |
| Value | Count | Frequency (%) | |
| NOT ON SCENE (DESK REPORT) | 247133 | 59.4% | |
| ON SCENE | 159211 | 38.3% | |
| (Missing) | 9854 | 2.4% |
Length
| Max length | 26 |
|---|---|
| Median length | 26 |
| Mean length | 18.5697865 |
| Min length | 3 |
CRASH_TYPE
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| NO INJURY / DRIVE AWAY | |
|---|---|
| INJURY AND / OR TOW DUE TO CRASH |
| Value | Count | Frequency (%) | |
| NO INJURY / DRIVE AWAY | 318202 | 76.5% | |
| INJURY AND / OR TOW DUE TO CRASH | 97996 | 23.5% |
Length
| Max length | 32 |
|---|---|
| Median length | 22 |
| Mean length | 24.3545524 |
| Min length | 22 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 323233 |
| Missing (%) | 77.7% |
| Memory size | 3.2 MiB |
| Y | |
|---|---|
| N | 4407 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 88558 | 21.3% | |
| N | 4407 | 1.1% | |
| (Missing) | 323233 | 77.7% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 298508 |
| Missing (%) | 71.7% |
| Memory size | 3.2 MiB |
| Y | |
|---|---|
| N | 5122 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 112568 | 27.0% | |
| N | 5122 | 1.2% | |
| (Missing) | 298508 | 71.7% |
DAMAGE
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| OVER $1,500 | |
|---|---|
| $501 - $1,500 | |
| $500 OR LESS |
| Value | Count | Frequency (%) | |
| OVER $1,500 | 236574 | 56.8% | |
| $501 - $1,500 | 124480 | 29.9% | |
| $500 OR LESS | 55144 | 13.2% |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 11.73067146 |
| Min length | 11 |
| Distinct count | 318866 |
|---|---|
| Unique (%) | 76.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| 02/26/2020 08:30:00 AM | 12 |
|---|---|
| 09/13/2019 05:00:00 PM | 11 |
| 01/12/2019 04:30:00 PM | 11 |
| 02/14/2020 05:00:00 PM | 11 |
| 06/30/2018 09:30:00 PM | 11 |
| Other values (318861) |
| Value | Count | Frequency (%) | |
| 02/26/2020 08:30:00 AM | 12 | < 0.1% | |
| 09/13/2019 05:00:00 PM | 11 | < 0.1% | |
| 01/12/2019 04:30:00 PM | 11 | < 0.1% | |
| 02/14/2020 05:00:00 PM | 11 | < 0.1% | |
| 06/30/2018 09:30:00 PM | 11 | < 0.1% | |
| 02/05/2020 05:00:00 PM | 10 | < 0.1% | |
| 05/14/2019 07:00:00 PM | 10 | < 0.1% | |
| 05/31/2019 04:00:00 PM | 10 | < 0.1% | |
| 04/10/2018 03:30:00 PM | 10 | < 0.1% | |
| 10/25/2017 04:30:00 PM | 10 | < 0.1% | |
| Other values (318856) | 416092 | > 99.9% |
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
PRIM_CONTRIBUTORY_CAUSE
Categorical
| Distinct count | 40 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| UNABLE TO DETERMINE | |
|---|---|
| FAILING TO YIELD RIGHT-OF-WAY | |
| FOLLOWING TOO CLOSELY | |
| NOT APPLICABLE | 22450 |
| IMPROPER OVERTAKING/PASSING | 20072 |
| Other values (35) |
| Value | Count | Frequency (%) | |
| UNABLE TO DETERMINE | 151188 | 36.3% | |
| FAILING TO YIELD RIGHT-OF-WAY | 46627 | 11.2% | |
| FOLLOWING TOO CLOSELY | 45719 | 11.0% | |
| NOT APPLICABLE | 22450 | 5.4% | |
| IMPROPER OVERTAKING/PASSING | 20072 | 4.8% | |
| IMPROPER BACKING | 18724 | 4.5% | |
| FAILING TO REDUCE SPEED TO AVOID CRASH | 17609 | 4.2% | |
| IMPROPER LANE USAGE | 16682 | 4.0% | |
| IMPROPER TURNING/NO SIGNAL | 14033 | 3.4% | |
| DRIVING SKILLS/KNOWLEDGE/EXPERIENCE | 12941 | 3.1% | |
| Other values (30) | 50153 | 12.1% |
Length
| Max length | 80 |
|---|---|
| Median length | 19 |
| Mean length | 23.72254552 |
| Min length | 6 |
SEC_CONTRIBUTORY_CAUSE
Categorical
| Distinct count | 40 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| NOT APPLICABLE | |
|---|---|
| UNABLE TO DETERMINE | |
| FAILING TO REDUCE SPEED TO AVOID CRASH | 17536 |
| DRIVING SKILLS/KNOWLEDGE/EXPERIENCE | 13368 |
| FAILING TO YIELD RIGHT-OF-WAY | 12833 |
| Other values (35) |
| Value | Count | Frequency (%) | |
| NOT APPLICABLE | 167090 | 40.1% | |
| UNABLE TO DETERMINE | 147957 | 35.5% | |
| FAILING TO REDUCE SPEED TO AVOID CRASH | 17536 | 4.2% | |
| DRIVING SKILLS/KNOWLEDGE/EXPERIENCE | 13368 | 3.2% | |
| FAILING TO YIELD RIGHT-OF-WAY | 12833 | 3.1% | |
| FOLLOWING TOO CLOSELY | 11846 | 2.8% | |
| IMPROPER OVERTAKING/PASSING | 6243 | 1.5% | |
| IMPROPER LANE USAGE | 6174 | 1.5% | |
| WEATHER | 5338 | 1.3% | |
| IMPROPER TURNING/NO SIGNAL | 4218 | 1.0% | |
| Other values (30) | 23595 | 5.7% |
Length
| Max length | 80 |
|---|---|
| Median length | 19 |
| Mean length | 19.71721152 |
| Min length | 6 |
STREET_NO
Real number (ℝ≥0)
| Distinct count | 10858 |
|---|---|
| Unique (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3602.1317882354074 |
|---|---|
| Minimum | 0 |
| Maximum | 451100 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 133 |
| Q1 | 1200 |
| median | 3119 |
| Q3 | 5504 |
| 95-th percentile | 8755 |
| Maximum | 451100 |
| Range | 451100 |
| Interquartile range (IQR) | 4304 |
Descriptive statistics
| Standard deviation | 2906.652766 |
|---|---|
| Coefficient of variation (CV) | 0.8069257141 |
| Kurtosis | 1349.602701 |
| Mean | 3602.131788 |
| Median Absolute Deviation (MAD) | 2118 |
| Skewness | 9.468342465 |
| Sum | 1499200046 |
| Variance | 8448630.299 |
| Value | Count | Frequency (%) | |
| 100 | 2824 | 0.7% | |
| 1600 | 2614 | 0.6% | |
| 200 | 2534 | 0.6% | |
| 800 | 2502 | 0.6% | |
| 300 | 2345 | 0.6% | |
| 500 | 2249 | 0.5% | |
| 6300 | 2107 | 0.5% | |
| 600 | 2096 | 0.5% | |
| 1200 | 2060 | 0.5% | |
| 4700 | 2029 | 0.5% | |
| Other values (10848) | 392838 | 94.4% |
| Value | Count | Frequency (%) | |
| 0 | 2 | < 0.1% | |
| 1 | 1748 | 0.4% | |
| 2 | 870 | 0.2% | |
| 3 | 278 | 0.1% | |
| 4 | 80 | < 0.1% |
| Value | Count | Frequency (%) | |
| 451100 | 1 | < 0.1% | |
| 34453 | 1 | < 0.1% | |
| 13799 | 3 | < 0.1% | |
| 13780 | 1 | < 0.1% | |
| 13770 | 13 | < 0.1% |
STREET_DIRECTION
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 3.2 MiB |
| W | |
|---|---|
| S | |
| N | |
| E | 28714 |
| Value | Count | Frequency (%) | |
| W | 148717 | 35.7% | |
| S | 136207 | 32.7% | |
| N | 102558 | 24.6% | |
| E | 28714 | 6.9% | |
| (Missing) | 2 | < 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.000009611 |
| Min length | 1 |
| Distinct count | 1549 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 3.2 MiB |
| WESTERN AVE | 11350 |
|---|---|
| PULASKI RD | 9890 |
| CICERO AVE | 9035 |
| ASHLAND AVE | 8938 |
| HALSTED ST | 7898 |
| Other values (1544) |
| Value | Count | Frequency (%) | |
| WESTERN AVE | 11350 | 2.7% | |
| PULASKI RD | 9890 | 2.4% | |
| CICERO AVE | 9035 | 2.2% | |
| ASHLAND AVE | 8938 | 2.1% | |
| HALSTED ST | 7898 | 1.9% | |
| KEDZIE AVE | 7011 | 1.7% | |
| MICHIGAN AVE | 5764 | 1.4% | |
| STATE ST | 5115 | 1.2% | |
| NORTH AVE | 4948 | 1.2% | |
| CLARK ST | 4933 | 1.2% | |
| Other values (1539) | 341315 | 82.0% |
Length
| Max length | 31 |
|---|---|
| Median length | 10 |
| Mean length | 10.68028438 |
| Min length | 3 |
BEAT_OF_OCCURRENCE
Real number (ℝ≥0)
| Distinct count | 275 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1246.7594775513342 |
|---|---|
| Minimum | 111.0 |
| Maximum | 6100.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 111 |
|---|---|
| 5-th percentile | 124 |
| Q1 | 714 |
| median | 1214 |
| Q3 | 1824 |
| 95-th percentile | 2512 |
| Maximum | 6100 |
| Range | 5989 |
| Interquartile range (IQR) | 1110 |
Descriptive statistics
| Standard deviation | 709.4833482 |
|---|---|
| Coefficient of variation (CV) | 0.5690619249 |
| Kurtosis | -1.018880184 |
| Mean | 1246.759478 |
| Median Absolute Deviation (MAD) | 590 |
| Skewness | 0.1389000038 |
| Sum | 518893814 |
| Variance | 503366.6213 |
| Value | Count | Frequency (%) | |
| 1834 | 5899 | 1.4% | |
| 122 | 4728 | 1.1% | |
| 114 | 4709 | 1.1% | |
| 1831 | 4688 | 1.1% | |
| 813 | 4185 | 1.0% | |
| 815 | 3946 | 0.9% | |
| 833 | 3357 | 0.8% | |
| 2413 | 3213 | 0.8% | |
| 1232 | 3163 | 0.8% | |
| 834 | 3096 | 0.7% | |
| Other values (265) | 375210 | 90.2% |
| Value | Count | Frequency (%) | |
| 111 | 2216 | 0.5% | |
| 112 | 1626 | 0.4% | |
| 113 | 1126 | 0.3% | |
| 114 | 4709 | 1.1% | |
| 121 | 2453 | 0.6% |
| Value | Count | Frequency (%) | |
| 6100 | 1 | < 0.1% | |
| 2535 | 1290 | 0.3% | |
| 2534 | 1702 | 0.4% | |
| 2533 | 2730 | 0.7% | |
| 2532 | 1080 | 0.3% |
NUM_UNITS
Real number (ℝ≥0)
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 1772 |
| Missing (%) | 0.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.021509268240892 |
|---|---|
| Minimum | 1.0 |
| Maximum | 18.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 18 |
| Range | 17 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4252291736 |
|---|---|
| Coefficient of variation (CV) | 0.2103523245 |
| Kurtosis | 38.4143551 |
| Mean | 2.021509268 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.135685352 |
| Sum | 837766 |
| Variance | 0.1808198501 |
| Value | Count | Frequency (%) | |
| 2 | 365967 | 87.9% | |
| 1 | 23147 | 5.6% | |
| 3 | 20475 | 4.9% | |
| 4 | 3600 | 0.9% | |
| 5 | 851 | 0.2% | |
| 6 | 233 | 0.1% | |
| 7 | 92 | < 0.1% | |
| 8 | 29 | < 0.1% | |
| 9 | 15 | < 0.1% | |
| 10 | 9 | < 0.1% | |
| Other values (5) | 8 | < 0.1% | |
| (Missing) | 1772 | 0.4% |
| Value | Count | Frequency (%) | |
| 1 | 23147 | 5.6% | |
| 2 | 365967 | 87.9% | |
| 3 | 20475 | 4.9% | |
| 4 | 3600 | 0.9% | |
| 5 | 851 | 0.2% |
| Value | Count | Frequency (%) | |
| 18 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 15 | 1 | < 0.1% | |
| 12 | 2 | < 0.1% | |
| 11 | 3 | < 0.1% |
MOST_SEVERE_INJURY
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2669 |
| Missing (%) | 0.6% |
| Memory size | 3.2 MiB |
| NO INDICATION OF INJURY | |
|---|---|
| NONINCAPACITATING INJURY | 27954 |
| REPORTED, NOT EVIDENT | 16255 |
| INCAPACITATING INJURY | 6439 |
| FATAL | 357 |
| Value | Count | Frequency (%) | |
| NO INDICATION OF INJURY | 362524 | 87.1% | |
| NONINCAPACITATING INJURY | 27954 | 6.7% | |
| REPORTED, NOT EVIDENT | 16255 | 3.9% | |
| INCAPACITATING INJURY | 6439 | 1.5% | |
| FATAL | 357 | 0.1% | |
| (Missing) | 2669 | 0.6% |
Length
| Max length | 24 |
|---|---|
| Median length | 23 |
| Mean length | 22.81441525 |
| Min length | 3 |
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2662 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.16713659753927107 |
|---|---|
| Minimum | 0.0 |
| Maximum | 21.0 |
| Zeros | 362531 |
| Zeros (%) | 87.1% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.5297513676 |
|---|---|
| Coefficient of variation (CV) | 3.169571329 |
| Kurtosis | 56.39700708 |
| Mean | 0.1671365975 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.267008107 |
| Sum | 69117 |
| Variance | 0.2806365115 |
| Value | Count | Frequency (%) | |
| 0 | 362531 | 87.1% | |
| 1 | 39134 | 9.4% | |
| 2 | 8066 | 1.9% | |
| 3 | 2403 | 0.6% | |
| 4 | 864 | 0.2% | |
| 5 | 317 | 0.1% | |
| 6 | 122 | < 0.1% | |
| 7 | 47 | < 0.1% | |
| 9 | 15 | < 0.1% | |
| 8 | 15 | < 0.1% | |
| Other values (8) | 22 | < 0.1% | |
| (Missing) | 2662 | 0.6% |
| Value | Count | Frequency (%) | |
| 0 | 362531 | 87.1% | |
| 1 | 39134 | 9.4% | |
| 2 | 8066 | 1.9% | |
| 3 | 2403 | 0.6% | |
| 4 | 864 | 0.2% |
| Value | Count | Frequency (%) | |
| 21 | 2 | < 0.1% | |
| 19 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 15 | 3 | < 0.1% | |
| 13 | 2 | < 0.1% |
INJURIES_FATAL
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2662 |
| Missing (%) | 0.6% |
| Memory size | 3.2 MiB |
| 0 | |
|---|---|
| 1 | 333 |
| 2 | 20 |
| 3 | 4 |
| Value | Count | Frequency (%) | |
| 0 | 413179 | 99.3% | |
| 1 | 333 | 0.1% | |
| 2 | 20 | < 0.1% | |
| 3 | 4 | < 0.1% | |
| (Missing) | 2662 | 0.6% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2662 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.01826443163352163 |
|---|---|
| Minimum | 0.0 |
| Maximum | 7.0 |
| Zeros | 407047 |
| Zeros (%) | 97.8% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1580884453 |
|---|---|
| Coefficient of variation (CV) | 8.655535988 |
| Kurtosis | 192.6168951 |
| Mean | 0.01826443163 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.61566853 |
| Sum | 7553 |
| Variance | 0.02499195654 |
| Value | Count | Frequency (%) | |
| 0 | 407047 | 97.8% | |
| 1 | 5713 | 1.4% | |
| 2 | 570 | 0.1% | |
| 3 | 143 | < 0.1% | |
| 4 | 49 | < 0.1% | |
| 5 | 11 | < 0.1% | |
| 7 | 2 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| (Missing) | 2662 | 0.6% |
| Value | Count | Frequency (%) | |
| 0 | 407047 | 97.8% | |
| 1 | 5713 | 1.4% | |
| 2 | 570 | 0.1% | |
| 3 | 143 | < 0.1% | |
| 4 | 49 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7 | 2 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 5 | 11 | < 0.1% | |
| 4 | 49 | < 0.1% | |
| 3 | 143 | < 0.1% |
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2662 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.09160024762052155 |
|---|---|
| Minimum | 0.0 |
| Maximum | 21.0 |
| Zeros | 384446 |
| Zeros (%) | 92.4% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3898124196 |
|---|---|
| Coefficient of variation (CV) | 4.255582596 |
| Kurtosis | 120.6937507 |
| Mean | 0.09160024762 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.336284575 |
| Sum | 37880 |
| Variance | 0.1519537225 |
| Value | Count | Frequency (%) | |
| 0 | 384446 | 92.4% | |
| 1 | 23281 | 5.6% | |
| 2 | 3975 | 1.0% | |
| 3 | 1169 | 0.3% | |
| 4 | 423 | 0.1% | |
| 5 | 142 | < 0.1% | |
| 6 | 58 | < 0.1% | |
| 7 | 19 | < 0.1% | |
| 8 | 6 | < 0.1% | |
| 10 | 5 | < 0.1% | |
| Other values (6) | 12 | < 0.1% | |
| (Missing) | 2662 | 0.6% |
| Value | Count | Frequency (%) | |
| 0 | 384446 | 92.4% | |
| 1 | 23281 | 5.6% | |
| 2 | 3975 | 1.0% | |
| 3 | 1169 | 0.3% | |
| 4 | 423 | 0.1% |
| Value | Count | Frequency (%) | |
| 21 | 2 | < 0.1% | |
| 18 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 14 | 1 | < 0.1% | |
| 11 | 4 | < 0.1% |
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2662 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.056340923160256906 |
|---|---|
| Minimum | 0.0 |
| Maximum | 11.0 |
| Zeros | 395564 |
| Zeros (%) | 95.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3022171841 |
|---|---|
| Coefficient of variation (CV) | 5.364079378 |
| Kurtosis | 98.97241035 |
| Mean | 0.05634092316 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.930155486 |
| Sum | 23299 |
| Variance | 0.09133522636 |
| Value | Count | Frequency (%) | |
| 0 | 395564 | 95.0% | |
| 1 | 14222 | 3.4% | |
| 2 | 2729 | 0.7% | |
| 3 | 689 | 0.2% | |
| 4 | 206 | < 0.1% | |
| 5 | 84 | < 0.1% | |
| 6 | 17 | < 0.1% | |
| 7 | 10 | < 0.1% | |
| 8 | 5 | < 0.1% | |
| 9 | 5 | < 0.1% | |
| Other values (2) | 5 | < 0.1% | |
| (Missing) | 2662 | 0.6% |
| Value | Count | Frequency (%) | |
| 0 | 395564 | 95.0% | |
| 1 | 14222 | 3.4% | |
| 2 | 2729 | 0.7% | |
| 3 | 689 | 0.2% | |
| 4 | 206 | < 0.1% |
| Value | Count | Frequency (%) | |
| 11 | 1 | < 0.1% | |
| 10 | 4 | < 0.1% | |
| 9 | 5 | < 0.1% | |
| 8 | 5 | < 0.1% | |
| 7 | 10 | < 0.1% |
| Distinct count | 42 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2662 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.017824324847172 |
|---|---|
| Minimum | 0.0 |
| Maximum | 61.0 |
| Zeros | 7217 |
| Zeros (%) | 1.7% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 61 |
| Range | 61 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.156723458 |
|---|---|
| Coefficient of variation (CV) | 0.5732528067 |
| Kurtosis | 88.06257539 |
| Mean | 2.017824325 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 4.289878612 |
| Sum | 834443 |
| Variance | 1.338009157 |
| Value | Count | Frequency (%) | |
| 2 | 198400 | 47.7% | |
| 1 | 122973 | 29.5% | |
| 3 | 51478 | 12.4% | |
| 4 | 19414 | 4.7% | |
| 5 | 8103 | 1.9% | |
| 0 | 7217 | 1.7% | |
| 6 | 3434 | 0.8% | |
| 7 | 1306 | 0.3% | |
| 8 | 596 | 0.1% | |
| 9 | 242 | 0.1% | |
| Other values (32) | 373 | 0.1% | |
| (Missing) | 2662 | 0.6% |
| Value | Count | Frequency (%) | |
| 0 | 7217 | 1.7% | |
| 1 | 122973 | 29.5% | |
| 2 | 198400 | 47.7% | |
| 3 | 51478 | 12.4% | |
| 4 | 19414 | 4.7% |
| Value | Count | Frequency (%) | |
| 61 | 1 | < 0.1% | |
| 50 | 1 | < 0.1% | |
| 45 | 1 | < 0.1% | |
| 42 | 3 | < 0.1% | |
| 40 | 2 | < 0.1% |
INJURIES_UNKNOWN
Boolean
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2662 |
| Missing (%) | 0.6% |
| Memory size | 3.2 MiB |
| 0 | |
|---|---|
| (Missing) | 2662 |
| Value | Count | Frequency (%) | |
| 0 | 413536 | 99.4% | |
| (Missing) | 2662 | 0.6% |
| Distinct count | 24 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.192122499387311 |
|---|---|
| Minimum | 0 |
| Maximum | 23 |
| Zeros | 7955 |
| Zeros (%) | 1.9% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 9 |
| median | 14 |
| Q3 | 17 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 5.466229452 |
|---|---|
| Coefficient of variation (CV) | 0.4143555711 |
| Kurtosis | -0.3949940867 |
| Mean | 13.1921225 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.3972465967 |
| Sum | 5490535 |
| Variance | 29.87966442 |
| Value | Count | Frequency (%) | |
| 16 | 31862 | 7.7% | |
| 15 | 31777 | 7.6% | |
| 17 | 31499 | 7.6% | |
| 14 | 28035 | 6.7% | |
| 18 | 25945 | 6.2% | |
| 13 | 25468 | 6.1% | |
| 12 | 24434 | 5.9% | |
| 8 | 23482 | 5.6% | |
| 11 | 21028 | 5.1% | |
| 9 | 20013 | 4.8% | |
| Other values (14) | 152655 | 36.7% |
| Value | Count | Frequency (%) | |
| 0 | 7955 | 1.9% | |
| 1 | 6789 | 1.6% | |
| 2 | 6029 | 1.4% | |
| 3 | 4973 | 1.2% | |
| 4 | 4621 | 1.1% |
| Value | Count | Frequency (%) | |
| 23 | 10014 | 2.4% | |
| 22 | 12149 | 2.9% | |
| 21 | 13130 | 3.2% | |
| 20 | 14633 | 3.5% | |
| 19 | 18707 | 4.5% |
CRASH_DAY_OF_WEEK
Real number (ℝ≥0)
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.124536879081591 |
|---|---|
| Minimum | 1 |
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.969188807 |
|---|---|
| Coefficient of variation (CV) | 0.477432707 |
| Kurtosis | -1.23070302 |
| Mean | 4.124536879 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.0721495666 |
| Sum | 1716624 |
| Variance | 3.877704559 |
| Value | Count | Frequency (%) | |
| 6 | 67592 | 16.2% | |
| 7 | 60950 | 14.6% | |
| 3 | 60300 | 14.5% | |
| 5 | 59884 | 14.4% | |
| 4 | 59524 | 14.3% | |
| 2 | 58058 | 13.9% | |
| 1 | 49890 | 12.0% |
| Value | Count | Frequency (%) | |
| 1 | 49890 | 12.0% | |
| 2 | 58058 | 13.9% | |
| 3 | 60300 | 14.5% | |
| 4 | 59524 | 14.3% | |
| 5 | 59884 | 14.4% |
| Value | Count | Frequency (%) | |
| 7 | 60950 | 14.6% | |
| 6 | 67592 | 16.2% | |
| 5 | 59884 | 14.4% | |
| 4 | 59524 | 14.3% | |
| 3 | 60300 | 14.5% |
CRASH_MONTH
Real number (ℝ≥0)
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.601134556148756 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.469570701 |
|---|---|
| Coefficient of variation (CV) | 0.5256021782 |
| Kurtosis | -1.224863741 |
| Mean | 6.601134556 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.03463350759 |
| Sum | 2747379 |
| Variance | 12.03792085 |
| Value | Count | Frequency (%) | |
| 10 | 38043 | 9.1% | |
| 6 | 37690 | 9.1% | |
| 12 | 36913 | 8.9% | |
| 5 | 36717 | 8.8% | |
| 11 | 35832 | 8.6% | |
| 9 | 34951 | 8.4% | |
| 1 | 34372 | 8.3% | |
| 3 | 33651 | 8.1% | |
| 2 | 32917 | 7.9% | |
| 8 | 32646 | 7.8% | |
| Other values (2) | 62466 | 15.0% |
| Value | Count | Frequency (%) | |
| 1 | 34372 | 8.3% | |
| 2 | 32917 | 7.9% | |
| 3 | 33651 | 8.1% | |
| 4 | 31344 | 7.5% | |
| 5 | 36717 | 8.8% |
| Value | Count | Frequency (%) | |
| 12 | 36913 | 8.9% | |
| 11 | 35832 | 8.6% | |
| 10 | 38043 | 9.1% | |
| 9 | 34951 | 8.4% | |
| 8 | 32646 | 7.8% |
| Distinct count | 188507 |
|---|---|
| Unique (%) | 45.5% |
| Missing | 2269 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.85715475635502 |
|---|---|
| Minimum | 0.0 |
| Maximum | 42.022779861 |
| Zeros | 29 |
| Zeros (%) | < 0.1% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 41.71443216 |
| Q1 | 41.78658293 |
| median | 41.877441 |
| Q3 | 41.92475429 |
| 95-th percentile | 41.9903545 |
| Maximum | 42.02277986 |
| Range | 42.02277986 |
| Interquartile range (IQR) | 0.13817136 |
Descriptive statistics
| Standard deviation | 0.3605778004 |
|---|---|
| Coefficient of variation (CV) | 0.008614484251 |
| Kurtosis | 12719.21078 |
| Mean | 41.85715476 |
| Median Absolute Deviation (MAD) | 0.06766827 |
| Skewness | -109.5963231 |
| Sum | 17325890.21 |
| Variance | 0.1300163502 |
| Value | Count | Frequency (%) | |
| 41.97620114 | 553 | 0.1% | |
| 41.79142028 | 274 | 0.1% | |
| 41.7514606 | 270 | 0.1% | |
| 41.72225727 | 223 | 0.1% | |
| 41.78932932 | 204 | < 0.1% | |
| 41.75466012 | 194 | < 0.1% | |
| 41.90095892 | 177 | < 0.1% | |
| 41.74257762 | 151 | < 0.1% | |
| 41.73638005 | 147 | < 0.1% | |
| 41.79291088 | 141 | < 0.1% | |
| Other values (188497) | 411595 | 98.9% | |
| (Missing) | 2269 | 0.5% |
| Value | Count | Frequency (%) | |
| 0 | 29 | < 0.1% | |
| 41.64467013 | 11 | < 0.1% | |
| 41.64469152 | 2 | < 0.1% | |
| 41.64469397 | 5 | < 0.1% | |
| 41.64470194 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 42.02277986 | 3 | < 0.1% | |
| 42.02273632 | 1 | < 0.1% | |
| 42.02272017 | 1 | < 0.1% | |
| 42.02266893 | 1 | < 0.1% | |
| 42.02266114 | 2 | < 0.1% |
| Distinct count | 188492 |
|---|---|
| Unique (%) | 45.5% |
| Missing | 2269 |
| Missing (%) | 0.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -87.6721175590124 |
|---|---|
| Minimum | -87.934014222 |
| Maximum | 0.0 |
| Zeros | 29 |
| Zeros (%) | < 0.1% |
| Memory size | 3.2 MiB |
Quantile statistics
| Minimum | -87.93401422 |
|---|---|
| 5-th percentile | -87.77636157 |
| Q1 | -87.72079453 |
| median | -87.67297631 |
| Q3 | -87.63296444 |
| 95-th percentile | -87.58608853 |
| Maximum | 0 |
| Range | 87.93401422 |
| Interquartile range (IQR) | 0.087830094 |
Descriptive statistics
| Standard deviation | 0.7361749743 |
|---|---|
| Coefficient of variation (CV) | -0.008396911069 |
| Kurtosis | 14089.92941 |
| Mean | -87.67211756 |
| Median Absolute Deviation (MAD) | 0.042428613 |
| Skewness | 118.3356283 |
| Sum | -36290031.95 |
| Variance | 0.5419535928 |
| Value | Count | Frequency (%) | |
| -87.90530913 | 553 | 0.1% | |
| -87.58014777 | 274 | 0.1% | |
| -87.58597199 | 270 | 0.1% | |
| -87.58527557 | 223 | 0.1% | |
| -87.74164564 | 204 | < 0.1% | |
| -87.74138476 | 194 | < 0.1% | |
| -87.61992817 | 177 | < 0.1% | |
| -87.63393693 | 151 | < 0.1% | |
| -87.62750922 | 147 | < 0.1% | |
| -87.74207734 | 141 | < 0.1% | |
| Other values (188482) | 411595 | 98.9% | |
| (Missing) | 2269 | 0.5% |
| Value | Count | Frequency (%) | |
| -87.93401422 | 1 | < 0.1% | |
| -87.93399393 | 15 | < 0.1% | |
| -87.9339765 | 1 | < 0.1% | |
| -87.93302828 | 2 | < 0.1% | |
| -87.92726168 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 29 | < 0.1% | |
| -87.52458739 | 3 | < 0.1% | |
| -87.52458901 | 2 | < 0.1% | |
| -87.52464032 | 1 | < 0.1% | |
| -87.52467395 | 4 | < 0.1% |
| Distinct count | 188585 |
|---|---|
| Unique (%) | 45.6% |
| Missing | 2269 |
| Missing (%) | 0.5% |
| Memory size | 3.2 MiB |
| POINT (-87.905309125103 41.976201139024) | 553 |
|---|---|
| POINT (-87.580147768689 41.791420282098) | 274 |
| POINT (-87.585971992965 41.751460603167) | 270 |
| POINT (-87.585275565077 41.722257273006) | 223 |
| POINT (-87.741645644196 41.789329323265) | 204 |
| Other values (188580) |
| Value | Count | Frequency (%) | |
| POINT (-87.905309125103 41.976201139024) | 553 | 0.1% | |
| POINT (-87.580147768689 41.791420282098) | 274 | 0.1% | |
| POINT (-87.585971992965 41.751460603167) | 270 | 0.1% | |
| POINT (-87.585275565077 41.722257273006) | 223 | 0.1% | |
| POINT (-87.741645644196 41.789329323265) | 204 | < 0.1% | |
| POINT (-87.741384758605 41.754660124394) | 194 | < 0.1% | |
| POINT (-87.619928173678 41.900958919109) | 177 | < 0.1% | |
| POINT (-87.633936930688 41.742577617335) | 151 | < 0.1% | |
| POINT (-87.627509219026 41.736380045588) | 147 | < 0.1% | |
| POINT (-87.742077342959 41.792910883497) | 141 | < 0.1% | |
| Other values (188575) | 411595 | 98.9% | |
| (Missing) | 2269 | 0.5% |
Length
| Max length | 40 |
|---|---|
| Median length | 40 |
| Mean length | 39.57757846 |
| Min length | 3 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| CRASH_RECORD_ID | RD_NO | CRASH_DATE | POSTED_SPEED_LIMIT | TRAFFIC_CONTROL_DEVICE | DEVICE_CONDITION | WEATHER_CONDITION | LIGHTING_CONDITION | FIRST_CRASH_TYPE | TRAFFICWAY_TYPE | LANE_CNT | ALIGNMENT | ROADWAY_SURFACE_COND | ROAD_DEFECT | REPORT_TYPE | CRASH_TYPE | INTERSECTION_RELATED_I | HIT_AND_RUN_I | DAMAGE | DATE_POLICE_NOTIFIED | PRIM_CONTRIBUTORY_CAUSE | SEC_CONTRIBUTORY_CAUSE | STREET_NO | STREET_DIRECTION | STREET_NAME | BEAT_OF_OCCURRENCE | NUM_UNITS | MOST_SEVERE_INJURY | INJURIES_TOTAL | INJURIES_FATAL | INJURIES_INCAPACITATING | INJURIES_NON_INCAPACITATING | INJURIES_REPORTED_NOT_EVIDENT | INJURIES_NO_INDICATION | INJURIES_UNKNOWN | CRASH_HOUR | CRASH_DAY_OF_WEEK | CRASH_MONTH | LATITUDE | LONGITUDE | LOCATION | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 073682ef84ff827659552d4254ad1b98bfec24935cc9cc4cbb796b0d17f98ce6028f4ac1795c51cdfa6cb6933de709f33cfe5171c175e4a0f5aebda62f2f61ce | JB460108 | 10/02/2018 06:30:00 PM | 10 | NO CONTROLS | NO CONTROLS | CLEAR | DARKNESS | PARKED MOTOR VEHICLE | OTHER | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | NaN | NaN | OVER $1,500 | 10/02/2018 07:35:00 PM | NOT APPLICABLE | NOT APPLICABLE | 517 | W | OHARE ST | 1654.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 18 | 3 | 10 | NaN | NaN | NaN |
| 1 | 1560fb8a1e32b528fef8bfd677d2b3fc5ab37278b157fa5ecf66064359bdad3803b9d298d234eb31f463d08515c791b5627fbf7afea3765d1c1a9f3befc5bdcc | JC325941 | 06/27/2019 04:00:00 PM | 45 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | SIDESWIPE SAME DIRECTION | ONE-WAY | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | NaN | NaN | OVER $1,500 | 06/27/2019 04:00:00 PM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 3 | W | TERMINAL ST | 1653.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 16 | 5 | 6 | NaN | NaN | NaN |
| 2 | 009e9e67203442370272e1a13d6ee51a4155dac65e583d1bdbee1fde686de7508c14ab5f205402f72644001276718917e02985561dc71b7d4bf945f09d7d47f5 | JA329216 | 06/30/2017 04:00:00 PM | 35 | STOP SIGN/FLASHER | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | TURNING | NOT DIVIDED | 4.0 | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | INJURY AND / OR TOW DUE TO CRASH | Y | NaN | OVER $1,500 | 06/30/2017 04:01:00 PM | FAILING TO YIELD RIGHT-OF-WAY | NOT APPLICABLE | 8301 | S | CICERO AVE | 834.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 16 | 6 | 6 | 41.741804 | -87.740954 | POINT (-87.740953581987 41.741803598989) |
| 3 | 00e47f189660cd8ba1e85fc63061bf1d8465184393f134fb8251ed7896a4ba9ed7c984ab51a01f564d6f4133c6ef8493b1a369743a4a308d4392900a286e160f | JC194776 | 03/21/2019 10:50:00 PM | 30 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DARKNESS, LIGHTED ROAD | TURNING | NOT DIVIDED | 4.0 | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | Y | NaN | OVER $1,500 | 03/21/2019 10:52:00 PM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 8301 | S | CICERO AVE | 834.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 22 | 5 | 3 | 41.741804 | -87.740954 | POINT (-87.740953581987 41.741803598989) |
| 4 | 0126747fc9ffc0edc9a38abb83d80034f897db0f739eef57f9bc75de8f2702a4c8f6dd8e49f5c2e810e1ec428bd9532fd0e6c583ca72669da9e65fc2a0a6de12 | JB200478 | 03/26/2018 02:23:00 PM | 35 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | PARKED MOTOR VEHICLE | NOT DIVIDED | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | NaN | $501 - $1,500 | 03/26/2018 03:20:00 PM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 3999 | N | AVONDALE AVE | 1732.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 14 | 2 | 3 | 41.953647 | -87.732082 | POINT (-87.732081736006 41.953646899951) |
| 5 | 5d672ce84d5b78346be822b388604bdf9cb3fa348a5adc89501859f857e1e9308e35ececb0a56527c6e6d065cc85e4e93302c1c57a97068034116e8b23ec2f4e | JD158927 | 02/20/2020 04:45:00 PM | 35 | TRAFFIC SIGNAL | OTHER | CLEAR | DAWN | REAR END | T-INTERSECTION | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | Y | NaN | $501 - $1,500 | 02/20/2020 04:51:00 PM | NOT APPLICABLE | NOT APPLICABLE | 12300 | W | IRVING PARK RD | 1654.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 16 | 5 | 2 | 41.958987 | -87.933994 | POINT (-87.933993928974 41.958986950953) |
| 6 | 0209e21f298984f7375742b7ef27c9880b485f41123a12b5a8eb14f01171abbbc05974399b985e05a352f801869cae0f41587f39a51994338fb82aeba853eece | JB415436 | 08/30/2018 05:45:00 PM | 30 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | TURNING | NOT DIVIDED | NaN | STRAIGHT AND LEVEL | DRY | UNKNOWN | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | Y | NaN | OVER $1,500 | 08/30/2018 05:58:00 PM | IMPROPER OVERTAKING/PASSING | IMPROPER LANE USAGE | 600 | W | DIVISION ST | 1822.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 17 | 5 | 8 | 41.903825 | -87.643286 | POINT (-87.643286359995 41.903825233976) |
| 7 | 0211e1f766f3940dfa87375661d25b716655e908c320cc46910e8fa5fb1f1e6a9d4f714d21e8e401ec9e0a12190b6cd9f6dbc97d32d0c0fc966a02ae516e782f | JC301403 | 06/11/2019 08:40:00 AM | 30 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | REAR END | DIVIDED - W/MEDIAN BARRIER | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | Y | NaN | $501 - $1,500 | 06/11/2019 09:05:00 AM | UNABLE TO DETERMINE | NOT APPLICABLE | 50 | E | GARFIELD BLVD | 225.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 8 | 3 | 6 | 41.794779 | -87.623828 | POINT (-87.623828038036 41.794778764028) |
| 8 | 02e2ed3606a50dda185f5e97c57a45552087d6fbea1c4b5f3777e0503da72279211f0518aabbeca2cd8e8ee1aca6cae3f88a0531cb62bb39ac156ca3d55e0931 | JB256393 | 05/09/2018 11:30:00 AM | 25 | NO CONTROLS | NO CONTROLS | RAIN | DAYLIGHT | ANGLE | NOT DIVIDED | 2.0 | STRAIGHT AND LEVEL | WET | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | NaN | NaN | OVER $1,500 | 05/09/2018 11:35:00 AM | FAILING TO YIELD RIGHT-OF-WAY | UNABLE TO DETERMINE | 9511 | S | WENTWORTH AVE | 511.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 11 | 4 | 5 | 41.721290 | -87.628510 | POINT (-87.628509593966 41.72128957001) |
| 9 | 03c8fee8a0cb0d303e972a873228b444a47b7b1ed1e2d97a8c409203dc81a9d97abc26692d325af7428a2f8f880ab0e551e763782226b9b6a0c3e19abd7ffa23 | JB317419 | 06/22/2018 07:25:00 AM | 35 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | RAIN | DAYLIGHT | TURNING | NOT DIVIDED | 6.0 | STRAIGHT AND LEVEL | WET | NO DEFECTS | ON SCENE | INJURY AND / OR TOW DUE TO CRASH | Y | NaN | OVER $1,500 | 06/22/2018 07:27:00 AM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 8301 | S | CICERO AVE | 834.0 | 2.0 | NONINCAPACITATING INJURY | 2.0 | 0.0 | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | 7 | 6 | 6 | 41.741804 | -87.740954 | POINT (-87.740953581987 41.741803598989) |
Last rows
| CRASH_RECORD_ID | RD_NO | CRASH_DATE | POSTED_SPEED_LIMIT | TRAFFIC_CONTROL_DEVICE | DEVICE_CONDITION | WEATHER_CONDITION | LIGHTING_CONDITION | FIRST_CRASH_TYPE | TRAFFICWAY_TYPE | LANE_CNT | ALIGNMENT | ROADWAY_SURFACE_COND | ROAD_DEFECT | REPORT_TYPE | CRASH_TYPE | INTERSECTION_RELATED_I | HIT_AND_RUN_I | DAMAGE | DATE_POLICE_NOTIFIED | PRIM_CONTRIBUTORY_CAUSE | SEC_CONTRIBUTORY_CAUSE | STREET_NO | STREET_DIRECTION | STREET_NAME | BEAT_OF_OCCURRENCE | NUM_UNITS | MOST_SEVERE_INJURY | INJURIES_TOTAL | INJURIES_FATAL | INJURIES_INCAPACITATING | INJURIES_NON_INCAPACITATING | INJURIES_REPORTED_NOT_EVIDENT | INJURIES_NO_INDICATION | INJURIES_UNKNOWN | CRASH_HOUR | CRASH_DAY_OF_WEEK | CRASH_MONTH | LATITUDE | LONGITUDE | LOCATION | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 416188 | e03b02d64d5d4db07c0c24fe1e9c495b4ac5b67cbe1e7334d16533b47b2a410bf1481830ec85ab046c4b391bf689476f68af6df1437f9e21cd10cacb10f7308a | JD236641 | 05/19/2020 01:00:00 PM | 25 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | REAR END | ONE-WAY | NaN | STRAIGHT AND LEVEL | WET | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | Y | $501 - $1,500 | 05/19/2020 02:30:00 PM | NOT APPLICABLE | NOT APPLICABLE | 1000 | S | KOLMAR AVE | 1131.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 13 | 3 | 5 | 41.869118 | -87.739401 | POINT (-87.739401314183 41.869117777281) |
| 416189 | f198c65371434926c14b2a63ed8792a1389fadaf675d8ee368dc5aaf1a30467a894c1412b2f099985c04308755ad76dfd1589de86c674ff6050c527539baee0d | JD236802 | 05/19/2020 03:31:00 PM | 30 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | TURNING | FOUR WAY | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | Y | NaN | $501 - $1,500 | 05/19/2020 03:51:00 PM | IMPROPER TURNING/NO SIGNAL | NOT APPLICABLE | 2001 | E | MARQUETTE DR | 331.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 15 | 3 | 5 | 41.775563 | -87.576444 | POINT (-87.576444451178 41.775562727526) |
| 416190 | f52f00333e5cac1530939b110da25a72de89372c032ae422467081eb937a8ff841ff2f5d73c28ededd41b765fad1e5681c1b039b5c02435bb9edb9ee97c94eab | JD236940 | 05/19/2020 06:21:00 PM | 30 | NO CONTROLS | NO CONTROLS | CLOUDY/OVERCAST | DAYLIGHT | SIDESWIPE SAME DIRECTION | DIVIDED - W/MEDIAN (NOT RAISED) | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | NaN | NaN | $500 OR LESS | 05/19/2020 06:21:00 PM | FAILING TO YIELD RIGHT-OF-WAY | NOT APPLICABLE | 2473 | N | CLARK ST | 1935.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 18 | 3 | 5 | 41.927478 | -87.641450 | POINT (-87.641449775903 41.927477726852) |
| 416191 | d97477e587b8eecbdb0dbce0a0c5462e7335a4f7da2e04c8e4799193cba69f0b887de56a831e8899031c1f7175e82a2ad8c43ba34260181a3e4e1bafda37ea88 | JD234027 | 05/16/2020 11:45:00 AM | 40 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | SIDESWIPE SAME DIRECTION | DIVIDED - W/MEDIAN BARRIER | NaN | CURVE, LEVEL | DRY | NO DEFECTS | ON SCENE | INJURY AND / OR TOW DUE TO CRASH | NaN | NaN | OVER $1,500 | 05/16/2020 11:55:00 AM | FAILING TO YIELD RIGHT-OF-WAY | NOT APPLICABLE | 120 | N | LAKE SHORE DR SB | 114.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 11 | 7 | 5 | 41.883642 | -87.615441 | POINT (-87.615441182232 41.883641778749) |
| 416192 | e43ffefbcb0c4518869aac0447be15af688b10f56d652adb93a204fc18d823594c6cf5e64bcf12134ee2e91a692e0434118a1367b5a5904e448f4cdbc850bfb5 | JD234946 | 05/17/2020 01:22:00 PM | 30 | NO CONTROLS | NO CONTROLS | RAIN | DAYLIGHT | PARKED MOTOR VEHICLE | DIVIDED - W/MEDIAN BARRIER | NaN | STRAIGHT AND LEVEL | WET | UNKNOWN | ON SCENE | INJURY AND / OR TOW DUE TO CRASH | NaN | NaN | $501 - $1,500 | 05/17/2020 01:22:00 PM | IMPROPER LANE USAGE | FAILING TO REDUCE SPEED TO AVOID CRASH | 1924 | W | GARFIELD BLVD | 932.0 | 3.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 13 | 1 | 5 | 41.794040 | -87.673019 | POINT (-87.673018619292 41.79403960152) |
| 416193 | de4cbde297443228427759c6d58f40254dc8d8fcb201dc731da85d4d0dcd05fd2fbb10974bc0d17cdecd4128959af5b2fc2a4b8a0ee42f3370be201aba68a5bd | JD235651 | 05/18/2020 12:20:00 PM | 10 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | REAR TO SIDE | PARKING LOT | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | NaN | $500 OR LESS | 05/18/2020 12:32:00 PM | FAILING TO YIELD RIGHT-OF-WAY | UNABLE TO DETERMINE | 1527 | W | LAWRENCE AVE | 1912.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 12 | 2 | 5 | 41.968773 | -87.668624 | POINT (-87.668624408172 41.968772794281) |
| 416194 | eb65bb1c2f912fbd1a80406813bbe831df2083d483334697387d443e911400cfad731b727f3ab2ab982ab9583e12ef1bba31838e50a2d4c3979a28223b8ef00f | JD235725 | 05/18/2020 09:00:00 AM | 30 | UNKNOWN | UNKNOWN | UNKNOWN | UNKNOWN | PARKED MOTOR VEHICLE | UNKNOWN | NaN | STRAIGHT AND LEVEL | UNKNOWN | UNKNOWN | NOT ON SCENE (DESK REPORT) | INJURY AND / OR TOW DUE TO CRASH | NaN | Y | OVER $1,500 | 05/18/2020 01:48:00 PM | UNABLE TO DETERMINE | NOT APPLICABLE | 4015 | N | PARKSIDE AVE | 1624.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 9 | 2 | 5 | 41.953658 | -87.768095 | POINT (-87.768095363598 41.953657967626) |
| 416195 | d35263055740651327a467ea3b5181fde21e1edad1e917c4096a7ca360f3ef47a2d3dc69666c6fc9bdfe7a9fdf8420654f251fcdf7c657bddc51a3a263e6eaf5 | JD236504 | 05/19/2020 02:00:00 AM | 20 | NO CONTROLS | NO CONTROLS | RAIN | DARKNESS, LIGHTED ROAD | PARKED MOTOR VEHICLE | ONE-WAY | NaN | STRAIGHT AND LEVEL | WET | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | NaN | $500 OR LESS | 05/19/2020 11:00:00 AM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 5700 | N | RICHMOND ST | 2011.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 2 | 3 | 5 | 41.985008 | -87.703007 | POINT (-87.70300710512 41.985008248097) |
| 416196 | d613f48076a4221ebaebf9fc31bf396baaf18892529f3f97474e6795d01eb9545440ed9dc0d31201c554798cce001416f0aff7f4214f3848bdb211d8f89915af | JD236487 | 05/19/2020 09:40:00 AM | 30 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | PARKED MOTOR VEHICLE | NOT DIVIDED | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | NaN | $501 - $1,500 | 05/19/2020 10:36:00 AM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 7715 | S | COTTAGE GROVE AVE | 624.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 9 | 3 | 5 | 41.754447 | -87.605136 | POINT (-87.605136112415 41.75444668619) |
| 416197 | f247683bbffde5cd7d1bddad30ff42c2d3d4594ffd218dc9bdbb270b88edac4d3e2c87a077ea21bede21d27eb2d508c8c9e0a42595a81d1221035e85aeea04cd | JD236796 | 05/19/2020 01:32:00 PM | 10 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | OTHER OBJECT | ALLEY | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | NaN | OVER $1,500 | 05/19/2020 03:46:00 PM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 925 | S | INDEPENDENCE BLVD | 1133.0 | 1.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 13 | 3 | 5 | 41.869263 | -87.719477 | POINT (-87.719476770345 41.869263306188) |